import pandas as pd

data = pd.read_excel("售后卡顿机器分析.xlsx", sheet_name='墨水屏售后机器')

fil_data = data[ #(data['研发定位'].isnull())
            #    (~ data['研发定位'].str.contains('老化测试',na=False))
           # & (data['详细描述'].isnull())
            (data['研发定位'].isnull())
            & (data["研发初筛"].str.contains("无ANR记录，试用无卡顿"))
           # & (data['问题分类'] != '硬件')
            & (data['机器归还日期'].isnull())
            ]

fil_data.to_excel("学练机.xlsx")